<?php session_start();
if (!isset($_SESSION["username"])) {
    header("Location:workerlogin.html");
} else {
    $username = $_SESSION['username'];
    $a = mysqli_connect("localhost", "root", "deng123", "housekeeping", "3306") or die("unable to connect");
    @$query = "SELECT * FROM admin_login where username='$username'";
    @$result = mysqli_query($a, $query);
    if ($result) {
        while ($row = mysqli_fetch_array($result)) {
            $dbusername = $row['username'];
            $dbquestion = $row['question'];
            $dbanswer = $row['answer'];
        }
?>
        <!DOCTYPE html>
        <html lang="en">

        <head>
            <!-- Required meta tags-->
            <meta charset="utf-8">
            <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
            <meta name="description" content="">
            <meta name="author" content="">
            <meta name="viewport" content="width=device-width, initial-scale=1">
            <title>好先生 | 家政服务</title>
            <link rel="shortcut icon" href="../img/favicon.ico" />
            <!-- Icons font CSS-->
            <link href="../vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
            <link href="../vendor/fontawesome-free/css/all.min.css" rel="stylesheet">
            <link rel="stylesheet" href="../vendor/simple-line-icons/css/simple-line-icons.css">
            <link href="https://fonts.googleapis.com/css?family=Lato" rel="stylesheet">
            <link href="https://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800,900"
                rel="stylesheet">
            <link href="https://fonts.googleapis.com/css?family=Muli" rel="stylesheet">
            <link href="../vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">
            <link href="../vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">

            <!-- Font special for pages-->
            <link
                href="https://fonts.googleapis.com/css?family=Poppins:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i"
                rel="stylesheet">

            <!-- Vendor CSS-->
            <link href="../vendor/select2/select2.min.css" rel="stylesheet" media="all">
            <link href="../css/hover-min.css" rel="stylesheet">


            <!-- Main CSS-->
            <link href="../css/style.css" rel="stylesheet" media="all">
            <link href="../css/main.css" rel="stylesheet" media="all">
        </head>

        <body>
            <nav class="navbar navbar-expand-lg navbar-light fixed-top"
                style="background:-webkit-gradient(linear, right top, left top, from(#1da1f2), to(#005f7f));"
                id="mainNav">
                <div class="container">
                    <div class="navbar-header">
                        <a class=" nav-link js-scroll-trigger" href="#top">
                            <img class="img-rounded" src="../img/logo.png" />
                        </a>
                    </div>
                    &nbsp;
                    <a class="navbar-brand " href="#page-top">
                        <h2>
                            <small style="font-family: Arial;border-bottom: 2px solid gainsboro">管理员面板</small>
                        </h2>
                    </a>
                    <button class="navbar-toggler navbar-toggler-right ml-auto" type="button" data-toggle="collapse"
                        data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false"
                        aria-label="Toggle navigation">
                        菜单
                        <i class="fas fa-bars"></i>
                    </button>
                    <div class="collapse navbar-collapse" id="navbarResponsive">
                        <ul class="navbar-nav ml-auto">
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow" href="profile.php">详情</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow " href="workers.php">员工</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow " href="customers.php">顾客</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow " href="bookings.php">预定</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow " href="queries.php">反馈</a>
                            </li>
                            <li class="nav-item">
                                <a class="nav-link js-scroll-trigger hvr-glow " href="logout.php">退出</a>
                            </li>
                        </ul>
                    </div>
                </div>
            </nav>
            <section class="features tb bb" id="features">
                <form action="profile.php" method="post">
                    <input type="submit" class="cont_button2 btn-dark" value="<< 返回">
                </form>
                <h1 class="mb-4 text-light">专业详情</h1>
                <table class="container1">
                    <tbody>
                        <tr>
                            <td>用户名</td>
                            <td><?php echo $dbusername; ?></td>
                        </tr>
                        <tr>
                            <td>安全问题</td>
                            <td><?php echo $dbquestion; ?></td>
                        </tr>
                        <tr>
                            <td>问题答案</td>
                            <td><?php echo $dbanswer; ?></td>
                        </tr>
                        <tr>
                            <td>北京市中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='北京市'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbghycentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbghycentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                        <tr>
                            <td>上海市中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='上海市'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbngncentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbngncentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                        <tr>
                            <td>广东省中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='广东省'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbtincentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbtincentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                        <tr>
                            <td>四川省中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='四川省'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbtezcentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbtezcentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                        <tr>
                            <td>湖北省中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='湖北省'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbjorcentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbjorcentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                        <tr>
                            <td>湖南省中心</td>
                            <?php
                            $q = "SELECT centre FROM cities where city='湖南省'";
                            $res = mysqli_query($a, $q);
                            if ($res) {
                                while ($row = mysqli_fetch_array($res)) {
                                    $dbdibcentre = $row['centre'];
                                }
                            ?>
                                <td><?php echo $dbdibcentre; ?></td>
                            <?php
                            }
                            ?>
                        </tr>
                    </tbody>
                </table>
                <div class="container1">
                    <form action="professional_edit.php" method="post">
                        <button id="contact_btn" type="submit" class="contact_button trans_100" style="float: right;" value="编辑">编辑</button>
                    </form>
                </div>
            </section>
            <!-- Jquery JS-->
            <script src="../vendor/jquery1/jquery.min.js"></script>
            <!-- Vendor JS-->
            <script src="../vendor/select2/select2.min.js"></script>
            <script src="../vendor/jquery-validate/jquery.validate.min.js"></script>
            <script src="../vendor/bootstrap-wizard/bootstrap.min.js"></script>
            <script src="../vendor/bootstrap-wizard/jquery.bootstrap.wizard.min.js"></script>
            <script src="../vendor/datepicker/moment.min.js"></script>
            <script src="../vendor/datepicker/daterangepicker.js"></script>
            <script src="../vendor/jquery/jquery.min.js"></script>
            <script src="../vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

            <!-- Plugin JavaScript -->
            <script src="../vendor/jquery-easing/jquery.easing.min.js"></script>


            <script src="../js/new-age.min.js"></script>

            <!-- Main JS-->
            <script src="../js/global.js"></script>
            <footer>
                <div class="container">
                    <p>&copy; 好先生 家政服务. 版权所有.</p>
                    <ul class="list-inline">
                        <li class="list-inline-item">
                            <a href="#">隐私</a>
                        </li>
                        <li class="list-inline-item">
                            <a href="#">条款</a>
                        </li>
                    </ul>
                </div>
            </footer>
        </body>
        <!-- end document-->

        </html>
<?php

    }
}
?>